Employee Master File (UK) - ACCEMPMAS

File Type	Physical
Record Format	ACCEMPMAS
Key Files

 

Action Description	Action Code	Action Allowed
Add	A	Y
Update	U	Y
Delete	D	N
Update/Add	X	Y
Clear File before Importing		N

 

Field Name	Key Field	Type	Len	Dec
Action		A	1
Company Code	Y	N	2	0
ID Number	Y	N	8	0
Title		A	4
Surname		A	24
First Forename		A	24
Second Forename		A	24
Maiden Name		A	24
Position ID		A	15
Address Line 1		A	40
Address Line 2		A	40
Address Line 3		A	40
Address Line 4		A	40
Country		A	30
Post Code		A	14
Date of Birth		D
Marital Status		A	1
Gender		A	1
Status		A	1
Tax Code		A	9
Wk1/Mth1 Indicator Note: Key *blank to change a non-cumulative tax code to cumulative.		A	1
Tax Code Prefix		A	1
National Insurance Number		A	10
NI Table Letter		A	1
Defer Date		D
Expiry Date		D
Evidence		A	30
Proof of Age Date Expiry Date		D
Proof of Age - Evidence		A	30
Pensioner Only		A	1
Director Basis		A	1
Director Appointment Week		N	5	2
Student Indicator		A	1
Date of Joining		D
Date of Leaving		D
Leave Period		N	2	0
P45 Period Left		N	6	0
Leave Reason		N	2	0
Department		A	4
Occupation Code		N	4	0
Cost Centre		A	2
Pay Point		A	4
Primary		A	24
Secondary		A	24
Reference 1		A	20
Reference 2		A	20
Employee Type		A	1
Annual Salary		N	13	2
Non-Payment Periods		N	2	0
Grade		A	8
Payslip Option		A	8
Weekly Basic Hours		N	5	2
Contractual Days/Week		N	3	2
Annual Hours		N	7	2
SSP Working Pattern		A	7
Sick Scheme Reference		A	8
Work Pattern		A	7
Payslip Option		A	1
Reset On-Line Password		A	1
Payslip Message 1		A	50
Payslip Message 2		A	50
Payment Method		A	1
Bank Account Number		A	8
Sort Code		N	6	0
Bank Account Name		A	30
Building Society Roll Number		A	18
Leave Date		D
Period Left		N	2	0
Week/Month		A	1
PAYE Reference		A	9
Previous Gross		N	13	2
Previous Tax		N	13	2
Tax District		A	4
Previous Employment Tax Code		A	9
Previous Employment Wk1/Mth 1 Indicator		A	1
P46 Statement		A	1
P46 (Expat) Indicator		A	1
Student Loan Note: Key N to stop an ongoing Student Loan.		A	1
Initial Annual Pension		N	9	2
Bereavement Indicator		A	1
YTD Gross		N	13	2
YTD Tax		N	13	2
Previous Employer Gross		N	13	2
Previous Employer Tax		N	13	2
Taxable Gross This Period		N	13	2
Taxable Gross YTD		N	13	2
Period Gross		N	13	2
Period Tax		N	13	2
Pension Main Scheme Number		N	2	0
Pension 2nd Scheme Number		N	2	0
Pension Main Scheme Reference No.		A	20
Pension 2nd Scheme Reference No.		A	20
Base Pensionable Pay		N	9	2
Continuous Service Date		D
Pension Enrolment Date (WPR)		D
Pension Opt-Out Date (WPR)		D
Pension Available Date (WPR)		D
Company Pension Join Date		D
Company Pension Leave Date		D
Irregular Payment		A	1
Payment to a non individual		A	1
On strike		A	1
Hours Worked		A	1
Period Pay Due		N	2	0
Payroll Reference		A	6
Apprentice Start Date		D
Apprentice End Date		D
Basic Pay Type		A	1
Basic Rate		N	9	5
Auto Pay Y/N		A	1
Effective Start Date		D
Effective End Date		D